questions = [
    {"name": "头痛", "tag": "neutral"},
    {"name": "神经过敏，心中不踏实", "tag": "fearful"},
    {"name": "头脑中有不必要的想法或字句盘旋", "tag": "disgusted"},
    {"name": "头昏或昏倒", "tag": "fearful"},
    {"name": "对异性的兴趣减退", "tag": "sad"},
    {"name": "对旁人责备求全", "tag": "angry"},
    {"name": "感到别人能控制自己的思想", "tag": "fearful"},
    {"name": "责怪别人制造麻烦", "tag": "angry"},
    {"name": "忘性大", "tag": "neutral"},
    {"name": "担心自己的衣饰整齐及仪态的端正", "tag": "fearful"},
    {"name": "容易烦恼和激动", "tag": "angry"},
    {"name": "胸痛", "tag": "fearful"},
    {"name": "害怕空旷的场所或街道", "tag": "fearful"},
    {"name": "感到自己的精力下降，活动减慢", "tag": "sad"},
    {"name": "想结束自己的生命", "tag": "sad"},
    {"name": "听到旁人听不到的声音", "tag": "fearful"},
    {"name": "发抖", "tag": "fearful"},
    {"name": "感到大多数人都不可信任", "tag": "disgusted"},
    {"name": "胃口不好", "tag": "sad"},
    {"name": "容易哭泣", "tag": "sad"},
    {"name": "同异性相处时感到害羞不自在", "tag": "fearful"},
    {"name": "受骗，中了圈套或有人想抓住", "tag": "fearful"},
    {"name": "无缘无故地突然感到害怕", "tag": "fearful"},
    {"name": "自己不能控制地大发脾气", "tag": "angry"},
    {"name": "怕单独出门", "tag": "fearful"},
    {"name": "经常责怪自己", "tag": "sad"},
    {"name": "腰痛", "tag": "neutral"},
    {"name": "感到难以完成任务", "tag": "sad"},
    {"name": "感到孤独", "tag": "sad"},
    {"name": "感到苦闷", "tag": "sad"},
    {"name": "过分担忧", "tag": "fearful"},
    {"name": "对事物不感兴趣", "tag": "sad"},
    {"name": "感到害怕", "tag": "fearful"},
    {"name": "我的感情容易受到伤害", "tag": "sad"},
    {"name": "旁人能知道自己的私下想法", "tag": "fearful"},
    {"name": "感到别人不理解自己、不同情自己", "tag": "sad"},
    {"name": "感到人们对自己不友好，不喜欢自己", "tag": "sad"},
    {"name": "做事必须做得很慢，以保证做得正确", "tag": "fearful"},
    {"name": "心跳得很厉害", "tag": "fearful"},
    {"name": "恶心或胃部不舒服", "tag": "sad"},
    {"name": "感到比不上他人", "tag": "sad"},
    {"name": "肌肉酸痛", "tag": "neutral"},
    {"name": "感到有人在监视自己、谈论自己", "tag": "fearful"},
    {"name": "难以入睡", "tag": "fearful"},
    {"name": "做事，必须反复检查", "tag": "fearful"},
    {"name": "难以作出决定", "tag": "fearful"},
    {"name": "怕乘电车、公共汽车、地铁或火车", "tag": "fearful"},
    {"name": "呼吸有困难", "tag": "fearful"},
    {"name": "一阵阵发冷或发热", "tag": "neutral"},
    {"name": "因为感到害怕而避开某些东西、场合或活动", "tag": "fearful"},
    {"name": "脑子变空了", "tag": "fearful"},
    {"name": "身体发麻或刺痛", "tag": "surprised"},
    {"name": "喉咙有梗塞感", "tag": "fearful"},
    {"name": "感到前途没有希望", "tag": "sad"},
    {"name": "不能集中注意", "tag": "fearful"},
    {"name": "感到身体的某一部分软弱无力", "tag": "fearful"},
    {"name": "感到紧张或容易紧张", "tag": "fearful"},
    {"name": "感到手或脚发重", "tag": "neutral"},
    {"name": "想到死亡的事", "tag": "sad"},
    {"name": "吃得太多", "tag": "neutral"},
    {"name": "当别人看着自己或谈论自己时感到不自在", "tag": "fearful"},
    {"name": "有一些不属于自己的想法", "tag": "fearful"},
    {"name": "有想打人或伤害他人的冲动", "tag": "angry"},
    {"name": "醒得太早", "tag": "fearful"},
    {"name": "必须反复洗手、点数目或触摸某些东西", "tag": "fearful"},
    {"name": "睡得不稳不深", "tag": "fearful"},
    {"name": "有想摔坏或破坏东西的冲动", "tag": "angry"},
    {"name": "有一些别人没有的想法或念头", "tag": "surprised"},
    {"name": "感到对别人神经过敏", "tag": "angry"},
    {"name": "在商店或电影院等人多的地方感到不自在", "tag": "fearful"},
    {"name": "感到任何事情都很困难", "tag": "sad"},
    {"name": "一阵阵恐惧或惊恐", "tag": "fearful"},
    {"name": "感到公共场合吃东西很不舒服", "tag": "fearful"},
    {"name": "经常与人争论", "tag": "angry"},
    {"name": "单独一人时神经很紧张", "tag": "fearful"},
    {"name": "别人对我的成绩没有作出恰当的价", "tag": "sad"},
    {"name": "即使和别人在一起也感到孤单", "tag": "sad"},
    {"name": "感到坐立不安心神不定", "tag": "fearful"},
    {"name": "感到自己没有什么价值", "tag": "sad"},
    {"name": "感到熟悉的东西变成陌生或不像真的", "tag": "fearful"},
    {"name": "大叫或摔东西", "tag": "angry"},
    {"name": "害怕会在公共场合昏倒", "tag": "fearful"},
    {"name": "感到别人想占自己的便宜", "tag": "fearful"},
    {"name": "为一些有关性的想法而苦恼", "tag": "sad"},
    {"name": "我认为应放为自己的过错而受到惩罚", "tag": "sad"},
    {"name": "感到要很快把事情做完", "tag": "fearful"},
    {"name": "感到自己的身体有严重问题", "tag": "fearful"},
    {"name": "从未感到和其他人很亲近", "tag": "sad"},
    {"name": "感到自己有罪", "tag": "sad"},
    {"name": "感到自己的脑子有毛病", "tag": "fearful"}
]

# 生成SQL插入语句
sql_statements = [
    "INSERT INTO question (name, tag) VALUES ('{}', '{}');".format(
        item['name'].replace("'", "''"), item['tag'])  # 防止SQL注入
    for item in questions
]

# 将所有SQL语句合并成一个字符串
sql_file_content = "\n".join(sql_statements)

# 指定要保存SQL文件的路径
sql_file_path = 'G:/data/names_sql_inserts.sql'

# 保存SQL语句到文件
with open(sql_file_path, 'w', encoding='utf-8') as file:
    file.write(sql_file_content)

# 输出文件路径，以便知道文件保存在哪里
print(sql_file_path)
